﻿CREATE TABLE [BritishGas].[BritishGasHabits]
(
	Id int NOT NULL Identity(1,1),
	SchoolId varchar(50) NOT NULL, 
	ClassName varchar(50) NOT NULL,
	Start datetime NOT NULL,
	[End] datetime NOT NULL,
	LightBulbsTotal Int,
	LightBulbsLeftOn Int,
	MonitorsTotal Int,
	MonitorsLeftOn Int,
	ComputersTotal Int,
	ComputersLeftOn Int,
	PrintersTotal Int,
	PrintersLeftOn Int,
	WhiteBoardsTotal Int,
	WhiteBoardsLeftOn Int,
	DeskLampsTotal Int,
	DeskLampsLeftOn Int,
	TelevisionsTotal Int,
	TelevisionsLeftOn Int,
	DVDsTotal Int,
	DVDsLeftOn Int,
	SickRoomAverage decimal(5,2),
	ClassRoomAverage decimal(5,2),
	HallsAverage decimal(5,2),
	WaterAverage decimal(5,2),
	HeatingOn bit,
	WindowsTotal int,
	WindowsOpen int,
	InternalDoorsTotal int,
	InternalDoorsOpen int,
	ExternalDoorsTotal int,
	ExternalDoorsOpen int,
	RadiatorsTotal int,
	RadiatorsObstructed int,
	ConcurencyId RowVersion
);
